Motivation

The report is developed to shed light on ethanol exports from Pakistan beginning year 2017.

Everything below is the result of computations performed on Ethanol Exports Database by computer program and displayed in the form of tables and charts. Where Microsoft Excel Dashboards have their weaknesses See Here and Microsoft Access reports are limited to desktops See Here,this method of reporting is not plagued by these weaknesses. Unlike Excel here the accuracy and consistency is guaranteed every time and reports can be constructed in an instant. With passing time I plan to make this more effective by adding some of my own insights to this and ensure that overall everything makes sense.

All prices of ethanol are in US Dollar on per metric ton basis indicated as M.Tons (Metric Tons).

  • Total observations from 2017 till date as below
    Observations
    9190

Year Wise Summary

Ethanol Summary Year Wise
Year Observations Percent Contribution (%) Value in Mil.USD Qty in M.Tons
2021 1184 12.88 283.94 315531.2
2020 2169 23.60 262.68 303117.4
2019 2157 23.47 257.12 375839.8
2018 2015 21.93 371.37 552463.8
2017 1665 18.12 378.95 565612.6

Storage Wise Summary

Ethanol Summary by Mode of Shipment
Storage Type Observations Percent Contribution(%) Value in Mil.USD Qty in M.Tons
SMALL PACK 8218 89.42 403.60 486548.3
BULK 972 10.58 1150.46 1626016.4

Product Wise Summary

Ethanol Summary by Product
Product Observations Percent Contribution (%) Value in Mil.USD Qty in M.Tons Max M.Ton Price Min M.Ton Price Mean M.Ton Price Median M.Ton Price
ENA 96% 5351 58.23 1032.48 1357542.13 3379.13 465.00 864.25 845.00
B-Grade (94.5%-92.5%) 3044 33.12 399.20 580039.87 1015.88 370.50 737.20 730.81
Anhydrous 99% 622 6.77 22.24 25815.86 2043.00 665.00 882.46 823.69
Hydrous 95.8% 173 1.88 100.14 149166.86 1523.38 534.25 714.47 655.00

Regionwise Summary

Ethanol Summary by Region
REGION Obs Percentage Contribution(%) Value in Mil.USD Qty in M.Tons Max.M.Ton Price Min.M.Ton Price Mean M.Ton Price Median M.Ton Price
ASIA 5211 56.70 901.58 1288336.27 1891.37 370.50 769.91 731.00
AFRICA 1929 20.99 140.61 165637.09 1451.13 598.00 854.49 853.88
MIDDLE EAST 1505 16.38 108.36 113752.57 3379.13 500.00 969.64 900.00
EUROPE 448 4.87 400.92 542025.32 1685.00 487.50 750.98 695.00
AUSTRALIA 87 0.95 2.08 2374.81 1550.00 550.00 861.78 900.00
AMERICA 10 0.11 0.51 438.66 1867.87 720.38 1011.89 907.88

1. Trend Analysis

Summary

2. Analysis by Product

Data Distribution

  • The following table shows total product distribution
    No. of Observations
    Product Observation
    ENA 96% 5351
    B-Grade (94.5%-92.5%) 3044
    Anhydrous 99% 622
    Hydrous 95.8% 173
  • The following table shows product distribution by year
    No. of Observations
    Year ENA 96% B-Grade (94.5%-92.5%) Anhydrous 99% Hydrous 95.8%
    2021 1044 71 55 14
    2020 1354 676 94 45
    2019 1169 787 164 37
    2018 899 881 194 41
    2017 885 629 115 36
  • The following table shows product distribution by storage
    No. of Observations
    Product SMALL PACK BULK
    ENA 96% 4703 648
    B-Grade (94.5%-92.5%) 2816 228
    Anhydrous 99% 620 2
    Hydrous 95.8% 79 94
  • The following table shows product distribution by regions
    No. of Observations
    REGION ENA 96% B-Grade (94.5%-92.5%) Anhydrous 99% Hydrous 95.8%
    ASIA 2968 1672 433 138
    AFRICA 1010 914 NA 5
    MIDDLE EAST 971 342 178 14
    EUROPE 339 91 2 16
    AUSTRALIA 55 24 8 NA
    AMERICA 8 1 1 NA
  • The major contribution of exports from Pakistan are due to countries in
    REGION
    ASIA
  • Among all regions in the world following has some of the highest prices overall
    REGION
    MIDDLE EAST

Product Wise Details Available Here

Values in Million USD.

Value in Mil. USD
Product 2021 2020 2019 2018 2017
ENA 96% 257.17 191.40 158.02 209.30 216.58
B-Grade (94.5%-92.5%) 14.14 57.14 77.32 124.40 126.20
Hydrous 95.8% 9.58 10.16 15.23 32.37 32.80
Anhydrous 99% 3.05 3.98 6.54 5.30 3.37

Quantity in M.Ton(Thousands)

Quantity in Thousand M.Ton
Product 2021 2020 2019 2018 2017
ENA 96% 1029.18 1412.66 878.68 645.56 658.53
Anhydrous 99% 59.40 95.82 135.95 160.14 97.58
B-Grade (94.5%-92.5%) 49.45 531.46 580.93 639.24 442.95
Hydrous 95.8% 11.95 39.94 23.75 25.62 22.34

Data Distribution

  • The following table shows distribution of product over years
    No. of Observations
    Product 2017 2018 2019 2020 2021
    ENA 96% 885 899 1169 1354 1044
    B-Grade (94.5%-92.5%) 629 881 787 676 71
    Anhydrous 99% 115 194 164 94 55
    Hydrous 95.8% 36 41 37 45 14

Plot

The plot below indicates price ranges of ethanol products over years.

For Price Outlier Details Click Here

3. Analysis by Region

Data Distribution

  • The following table shows total region distribution
    No. of Observations
    REGION Observation
    ASIA 5211
    AFRICA 1929
    MIDDLE EAST 1505
    EUROPE 448
    AUSTRALIA 87
    AMERICA 10
  • The following table shows distribution of regions by year
    No. of Observations
    Year ASIA MIDDLE EAST EUROPE AFRICA AUSTRALIA AMERICA
    2021 805 227 80 50 22 NA
    2020 1026 587 131 393 28 4
    2019 1131 291 70 645 16 4
    2018 1209 240 82 474 9 1
    2017 1040 160 85 367 12 1
  • The following table shows region distribution by storage
    No. of Observations
    REGION SMALL PACK BULK
    ASIA 4637 574
    AFRICA 1915 14
    MIDDLE EAST 1462 43
    EUROPE 107 341
    AUSTRALIA 87 NA
    AMERICA 10 NA
  • The following table shows distribution of regions by product
    No. Of Observation
    Product ASIA AFRICA MIDDLE EAST EUROPE AUSTRALIA AMERICA
    ENA 96% 2968 1010 971 339 55 8
    B-Grade (94.5%-92.5%) 1672 914 342 91 24 1
    Anhydrous 99% 433 NA 178 2 8 1
    Hydrous 95.8% 138 5 14 16 NA NA
  • Highest prices can be seen from the graph below
    Product
    ENA 96%

Values in Million USD.

Value in Mil. USD
REGION 2021 2020 2019 2018 2017
ASIA 168.19 88.08 134.32 250.99 260.00
EUROPE 98.01 89.25 62.58 74.28 76.79
MIDDLE EAST 11.87 54.14 15.56 12.59 14.20
AFRICA 5.02 30.02 44.41 33.38 27.79
AUSTRALIA 0.86 0.76 0.20 0.11 0.15
AMERICA NA 0.43 0.05 0.01 0.01

Quantity in M.Ton(Thousands)

Quantity in Thousand M.Ton
REGION 2021 2020 2019 2018 2017
ASIA 756.03 896.84 794.05 839.72 725.35
MIDDLE EAST 244.76 690.70 220.08 180.87 122.89
EUROPE 74.11 104.11 47.35 54.79 56.07
AFRICA 53.83 359.57 541.77 387.41 305.73
AUSTRALIA 21.26 23.81 12.62 6.78 10.49
AMERICA NA 4.84 3.44 0.97 0.87

Regionwise Details Available Here

Data Distribution

  • The following tables shows distribution of Regions over years
    No.of Observation
    REGION 2017 2018 2019 2020 2021
    ASIA 1040 1209 1131 1026 805
    AFRICA 367 474 645 393 50
    MIDDLE EAST 160 240 291 587 227
    EUROPE 85 82 70 131 80
    AUSTRALIA 12 9 16 28 22
    AMERICA 1 1 4 4 NA

Plot

The plot below indicates price ranges of Regions over years.

For Price Outlier Details Click Here

4. Country wise Analysis

Plot

The prices in “M.Tons (Metric Tons)” are plotted with respect to time for all countries as below.

For Interactive Plot Click Here

Data Distribution

  • Countries Available For Analysis
    Count
    66
  • The following are the country wise contributions by year
  • The following are the country wise contributions by Product
  • The following are the country wise contributions by Storage

5. Exporter wise Analysis

  • Total Exporters Available For Analysis
    Count
    22

Plot

The plot below indicates price ranges of Exporters over years.

For Price Outlier Details Click Here

Data Distribution

  • The following is the exporter wise contribution by Year
  • The following are the exporter wise contributions by Product
  • The following are the exporter wise contributions by Storage

6. Importer wise Analysis

Importer Details Available Here

  • Total Importers Available For Analysis
    Observations
    310

Importerwise Summary